Domains limits and constraints
This section provides an overview of the limits that need to be considered when working with domains in Engine.
Combining Domains
Domains can be combined across a maximum of 3 links. The type of link is not important.
Modifying Column Templates
When adding columns to a Domain's Column Template it is not possible to add columns from the MANY side at the ONE side:
Max Domains in System
The maximum number of domains that can be present in a system is determined by the maximum allowable system objects (256,000) and the available memory.
Max Size of Recordset for sorting
The maximum size of recordset that can be sorted is dependent on the memory that is available to the Engine process:
Max Sort Size = Free Memory/4
The available memory to the Engine process can be calculated using the dispatch call ND_GDI_AVAILABLEPHYSICAL:
Dim lMem As Long
Dim oSess as ISession
Dim oRS as IRecordset
Dim lNumRows as Long
' //Const ND_GDI_AVAILABLEPHYSICAL = 112
' //Const ND_GET_STATUS_INFO= 1000
…
lNumRows = oRS.NumRows
lMem = oSes.NucleusDisp(ND_GET_STATUS_INFO, ND_GDI_AVAILABLEPHYSICAL)
If (lMem/4) > lNumRows then
MsgBox “There is not enough memory to sort the recordset”
End If
Domain Streaming
From Engine 5.0 onwards there is no implicit domain streaming; it occurs automatically and is controlled by the operating system.
